set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


create PROCEDURE [dbo].[InsertNews]
	@Title nvarchar(100),
	@SubTitle nvarchar(100),
	@Labels nvarchar(200),
	@Summary nvarchar(500),
	@content text,
	@isRelease_id int,
	@checkUser_id int,
	@createuser_id int
AS
BEGIN
	declare @id  int
	set @id=(select max(id) from newsinfo)+1	
	insert into 
	newsinfo(
	id,
	title,
	subtitle,
	[content],
	createuser_id,
	createdate,
	isrelease_id,
	checkuser_id,
	labels,
	summary,
	url,
	releaseddate
	)
	values(
	@id,
	@Title,
	@SubTitle,
	@content,
	@createuser_id,
	getdate(),
	@isRelease_id,
	@checkUser_id,
	@Labels,
	@Summary,
	null,
	getdate()
	)
END

